Table fields are managed on the Fields tab of the Table Designer. Just simply click a field for editing. By using the toolbar below, you can create new, insert, move and drop the selected field.
Add Field
To add a field to the table
- Open the table in the Table Designer.
- Open the Fields tab.
- Click the
Add Field from the toolbar.
- Edit field properties.
Insert Field
To insert a field above an existing field
- Open the table in the Table Designer.
- Open the Fields tab.
- Select field.
- Click the
Insert Field from the toolbar.
- Define field properties in the empty row.
Note: Support from MySQL 3.22 or later.
Edit Field
To edit the table field
- Open the table in the Table Designer.
- Open the Fields tab.
- Simply click on the field to edit.
To change the order of the table fields
- Open the table in the Table Designer.
- Open the Fields tab.
- Select the field to move and click the
Move Up/
Move Down from the toolbar.
Note: Support from MySQL 4.0.1 or later.
Delete Field
To delete the table field
- Open the table in the Table Designer.
- Open the Fields tab.
- Click the
Delete Field from the toolbar.
- Confirm deleting in the dialog window.
See also:
Setting Field Properties
Setting Other Field Properties